
<html><HEAD>
<LINK REL=STYLESHEET HREF="default.css" TYPE="text/css">
<TITLE>
Preparing to use the ADO.NET interface</TITLE>
</HEAD>
<BODY>

<!-- Header -->
<p class="ancestor" align="right"><A HREF="connpbp26.htm">Previous</A>&nbsp;&nbsp;<A HREF="connpbp28.htm" >Next</A>
<!-- End Header -->
<A NAME="BABCCHIDN"></A><h1>Preparing to use the ADO.NET interface</h1>
<A NAME="TI600"></A><p>Before you define the interface and connect to a database
using ADO.NET: <A NAME="TI601"></A>
<ol>
</li>
<li class=ds>Install and configure the database
server, network, and client software.</li>
<li class=ds>Install the ADO.NET interface.</li>
<li class=ds>Install Microsoft's Data Access Components
version 2.6 or higher software on your machine.
</li>
</ol>
</p>
<A NAME="TI602"></A><h4>Step 1: Install and configure the data server</h4>
<A NAME="TI603"></A><p>You must install and configure the database server and install
the network software and client software.</p>
<A NAME="TI604"></A><p><img src="images/proc.gif" width=17 height=17 border=0 align="bottom" alt="Steps"> To install and configure the database server,
network, and client software:</p>
<ol><li class=fi><p>Make sure the appropriate database software
is installed and running on its server.</p><p>You must obtain the database server software from your database
vendor. For installation instructions, see your database vendor's
documentation.</p></li>
<li class=ds><p>Make sure the required network software (such
as TCP/IP) is installed and running on your computer and
is properly configured so that you can connect to the data server
at your site. You must install the network communication driver
that supports the network protocol and operating system platform
you are using.</p><p>For installation and configuration instructions,
see your network or data source administrator.</p></li>
<li class=ds><p>If required, install the appropriate client software
on each client computer on which PowerBuilder is installed. </p><p><img src="images/note.gif" width=17 height=17 border=0 align="bottom" alt="Note"> <span class=shaded>Client software requirements </span> <A NAME="TI605"></A>To determine client software requirements, see your database
vendor's documentation. </p>
</li></ol>
<br><A NAME="TI606"></A><h4>Step 2: Install the ADO.NET interface </h4>
<A NAME="TI607"></A><p>In the PowerBuilder Setup program, select the Custom install
and select the ADO.NET database interface. </p>
<A NAME="TI608"></A><h4>Step 3: Install the Microsoft Data Access Components
software</h4>
<A NAME="TI609"></A><p>The PowerBuilder ADO.NET interface requires the functionality
of the Microsoft Data Access Components (MDAC) version 2.8 or higher
software. Version 2.8 is distributed with Windows XP Service Pack
2 and Windows Server 2003. </p>
<A NAME="TI610"></A><p>To check the version of MDAC on your computer, you can download
and run the MDAC Component Checker utility from the <A HREF="http://msdn.microsoft.com/en-us/data/aa937730.aspx">MDAC Downloads page</A>
.</p>
<A NAME="TI611"></A><p>On the Windows Vista operating system, Windows Data Access
Components (DAC) 6.0 includes some changes to work with Vista but
is otherwise functionally equivalent to MDAC 2.8.</p>
<p><img src="images/note.gif" width=17 height=17 border=0 align="bottom" alt="Note"> <span class=shaded>OLE DB data providers installed with MDAC</span> <A NAME="TI612"></A>Several Microsoft OLE DB data providers are automatically
installed with MDAC, including the providers for <ACRONYM title = "sequel" >SQL</ACRONYM> Server (SQLOLEDB) and ODBC (MSDASQL).</p>

